package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.ruoyi.system.domain.ERP.MaterialDataErp;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * erp物料主数据Mapper接口
 *
 * @author ruoyi
 * @date 2023-03-27
 */
public interface MaterialDataErpMapper extends BaseMapper<MaterialDataErp> {

    @Select("select t.* from material_data_erp t inner join material_type_erp t1 on t.inv_c_code=t1.inv_class_code where SUBSTRING(t1.inv_class_name,1,2)='HW'")
    MaterialDataErp selectByCode(String fMaterielCode);

    List<MaterialDataErp> getList(MaterialDataErp materialDataErp);
}
